Overview

Dataset Statistics

Number of Variables 19
Number of Rows 50
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 16.4 KB
Average Row Size in Memory 335.5 B
Variable Types
  • Categorical: 5
  • Numerical: 14

Dataset Insights

Rsrp_variance and Rssnr_variance have similar distributions Similar Distribution
Rsrp_variance and Rssi_variance have similar distributions Similar Distribution
Rssnr_variance and Rssi_variance have similar distributions Similar Distribution
Count_data_points is skewed Skewed
Velocity_mean is skewed Skewed
Rssi_mean is skewed Skewed
Rssnr_variance is skewed Skewed
Rssi_variance is skewed Skewed
Wifi_data_points_share is skewed Skewed
Radius_activity_user is skewed Skewed
Id has constant length 32 Constant Length
Weekday has constant length 1 Constant Length
Velocity_mean has 19 (38.0%) negatives Negatives
Rsrp_mean has 50 (100.0%) negatives Negatives
Rsrq_mean has 50 (100.0%) negatives Negatives
Rssnr_mean has 8 (16.0%) negatives Negatives
Rssi_mean has 44 (88.0%) negatives Negatives
Velocity_mean has 11 (22.0%) zeros Zeros
Rssi_mean has 6 (12.0%) zeros Zeros
Rsrp_variance has 5 (10.0%) zeros Zeros
Rsrq_variance has 6 (12.0%) zeros Zeros
Rssnr_variance has 5 (10.0%) zeros Zeros
Rssi_variance has 14 (28.0%) zeros Zeros
Wifi_data_points_share has 12 (24.0%) zeros Zeros
Radius_activity_user has 9 (18.0%) zeros Zeros
  • 1
  • 2
  • 3

Variables


Id

categorical

Approximate Distinct Count 45
Approximate Unique (%) 90.0%
Missing 0
Missing (%) 0.0%
Memory Size 4.7 KB

Length

Mean 32
Standard Deviation 0
Median 32
Minimum 32
Maximum 32

Sample

1st row 00185484897c4ff999...
2nd row 00185484897c4ff999...
3rd row 005c51d817bb4266a2...
4th row 00665dc575c54173a3...
5th row 009d40c7f7a1493c80...

Letter

Count 541
Lowercase Letter 541
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 1059
  • Id has words of constant length

Calendar_week

numerical

Approximate Distinct Count 24
Approximate Unique (%) 48.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 600.0 B
Mean 30.56
Minimum 17
Maximum 44
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Calendar_week is skewed right (γ1 = 0.0346)

Quantile Statistics

Minimum 17
5-th Percentile 18.45
Q1 22.76
Median 32
Q3 39
95-th Percentile 43
Maximum 44
Range 27
IQR 16.24

Descriptive Statistics

Mean 30.56
Standard Deviation 8.4929
Variance 72.129
Sum 1528
Skewness 0.03465
Kurtosis -1.341
Coefficient of Variation 0.2779
  • Calendar_week is not normally distributed (p-value 0.001895981271598124)

Weekday

categorical

Approximate Distinct Count 7
Approximate Unique (%) 14.0%
Missing 0
Missing (%) 0.0%
Memory Size 3.2 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 6
2nd row 4
3rd row 7
4th row 6
5th row 3

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 50
  • Weekday has words of constant length

Month

categorical

Approximate Distinct Count 6
Approximate Unique (%) 12.0%
Missing 0
Missing (%) 0.0%
Memory Size 3.2 KB

Length

Mean 1.26
Standard Deviation 0.4431
Median 1
Minimum 1
Maximum 2

Sample

1st row 5
2nd row 8
3rd row 8
4th row 10
5th row 7

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 63

Weekend

categorical

Approximate Distinct Count 2
Approximate Unique (%) 4.0%
Missing 0
Missing (%) 0.0%
Memory Size 3.4 KB
  • The largest value (False) is over 3.55 times larger than the second largest value (True)

Length

Mean 4.78
Standard Deviation 0.4185
Median 5
Minimum 4
Maximum 5

Sample

1st row True
2nd row False
3rd row True
4th row True
5th row False

Letter

Count 239
Lowercase Letter 189
Space Separator 0
Uppercase Letter 50
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (False, True) take over 50.0%
  • The largest value (false) is over 3.55 times larger than the second largest value (true)

Count_data_points

numerical

Approximate Distinct Count 36
Approximate Unique (%) 72.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 67.88
Minimum 2
Maximum 521
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Count_data_points is skewed right (γ1 = 2.686)

Quantile Statistics

Minimum 2
5-th Percentile 3
Q1 7.5
Median 33.5
Q3 80.5
95-th Percentile 271.7
Maximum 521
Range 519
IQR 73

Descriptive Statistics

Mean 67.88
Standard Deviation 96.7312
Variance 9356.9241
Sum 3394
Skewness 2.686
Kurtosis 8.4864
Coefficient of Variation 1.425
  • Count_data_points is not normally distributed (p-value 3.2693909920300996e-19)
  • Count_data_points has 4 outliers

Velocity_mean

numerical

Approximate Distinct Count 26
Approximate Unique (%) 52.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 0.6055
Minimum -1
Maximum 24.8913
Zeros 11
Zeros (%) 22.0%
Negatives 19
Negatives (%) 38.0%
  • Velocity_mean is skewed right (γ1 = 4.939)

Quantile Statistics

Minimum -1
5-th Percentile -1
Q1 -1
Median 0
Q3 0.1652
95-th Percentile 1.0985
Maximum 24.8913
Range 25.8913
IQR 1.1652

Descriptive Statistics

Mean 0.6055
Standard Deviation 4.1665
Variance 17.3597
Sum 30.273
Skewness 4.939
Kurtosis 24.1339
Coefficient of Variation 6.8816
  • Velocity_mean is not normally distributed (p-value 4.09199339039435e-15)
  • Velocity_mean has 2 outliers

Rsrp_mean

numerical

Approximate Distinct Count 50
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean -103.6739
Minimum -122
Maximum -79
Zeros 0
Zeros (%) 0.0%
Negatives 50
Negatives (%) 100.0%
  • Rsrp_mean is skewed right (γ1 = 0.3955)

Quantile Statistics

Minimum -122
5-th Percentile -116.9961
Q1 -109.4288
Median -104.7096
Q3 -97.6933
95-th Percentile -88.6
Maximum -79
Range 43
IQR 11.7356

Descriptive Statistics

Mean -103.6739
Standard Deviation 9.372
Variance 87.8349
Sum -5183.6942
Skewness 0.3955
Kurtosis -0.2193
Coefficient of Variation -0.0904
  • Rsrp_mean has 1 outliers

Rsrq_mean

numerical

Approximate Distinct Count 49
Approximate Unique (%) 98.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean -10.2848
Minimum -16.6452
Maximum -5
Zeros 0
Zeros (%) 0.0%
Negatives 50
Negatives (%) 100.0%
  • Rsrq_mean is skewed left (γ1 = -0.4242)

Quantile Statistics

Minimum -16.6452
5-th Percentile -14.8683
Q1 -11.4202
Median -9.7048
Q3 -8.875
95-th Percentile -6.4277
Maximum -5
Range 11.6452
IQR 2.5452

Descriptive Statistics

Mean -10.2848
Standard Deviation 2.5378
Variance 6.4402
Sum -514.2377
Skewness -0.4242
Kurtosis 0.0629
Coefficient of Variation -0.2467
  • Rsrq_mean is not normally distributed (p-value 0.0006109033646286802)
  • Rsrq_mean has 2 outliers

Rssnr_mean

numerical

Approximate Distinct Count 47
Approximate Unique (%) 94.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 6.5157
Minimum -42.1622
Maximum 31.4286
Zeros 0
Zeros (%) 0.0%
Negatives 8
Negatives (%) 16.0%
  • Rssnr_mean is skewed left (γ1 = -1.4589)

Quantile Statistics

Minimum -42.1622
5-th Percentile -9.714
Q1 2.0784
Median 6.2861
Q3 12.8625
95-th Percentile 26.85
Maximum 31.4286
Range 73.5907
IQR 10.784

Descriptive Statistics

Mean 6.5157
Standard Deviation 13.2038
Variance 174.3398
Sum 325.7851
Skewness -1.4589
Kurtosis 4.6718
Coefficient of Variation 2.0265
  • Rssnr_mean is not normally distributed (p-value 3.937073558888268e-05)
  • Rssnr_mean has 6 outliers

Rssi_mean

numerical

Approximate Distinct Count 41
Approximate Unique (%) 82.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean -79.4579
Minimum -113
Maximum 0
Zeros 6
Zeros (%) 12.0%
Negatives 44
Negatives (%) 88.0%
  • Rssi_mean is skewed right (γ1 = 1.3178)

Quantile Statistics

Minimum -113
5-th Percentile -112.7
Q1 -106.0539
Median -95.7927
Q3 -69.3839
95-th Percentile 0
Maximum 0
Range 113
IQR 36.67

Descriptive Statistics

Mean -79.4579
Standard Deviation 37.9355
Variance 1439.1049
Sum -3972.8958
Skewness 1.3178
Kurtosis 0.3208
Coefficient of Variation -0.4774
  • Rssi_mean is not normally distributed (p-value 1.8075870962103684e-08)
  • Rssi_mean has 8 outliers

Rsrp_variance

numerical

Approximate Distinct Count 46
Approximate Unique (%) 92.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 4.8798
Minimum 0
Maximum 13.6101
Zeros 5
Zeros (%) 10.0%
Negatives 0
Negatives (%) 0.0%
  • Rsrp_variance is skewed right (γ1 = 0.5689)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 2.2162
Median 4.4229
Q3 6.8526
95-th Percentile 10.1868
Maximum 13.6101
Range 13.6101
IQR 4.6364

Descriptive Statistics

Mean 4.8798
Standard Deviation 3.4573
Variance 11.9529
Sum 243.9878
Skewness 0.5689
Kurtosis -0.2751
Coefficient of Variation 0.7085
  • Rsrp_variance is not normally distributed (p-value 0.0018996439102190094)

Rsrq_variance

numerical

Approximate Distinct Count 45
Approximate Unique (%) 90.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 1.6553
Minimum 0
Maximum 3.8616
Zeros 6
Zeros (%) 12.0%
Negatives 0
Negatives (%) 0.0%
  • Rsrq_variance is skewed right (γ1 = 0.1302)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0.8029
Median 1.6754
Q3 2.3594
95-th Percentile 3.4231
Maximum 3.8616
Range 3.8616
IQR 1.5566

Descriptive Statistics

Mean 1.6553
Standard Deviation 1.0665
Variance 1.1375
Sum 82.7649
Skewness 0.1302
Kurtosis -0.8482
Coefficient of Variation 0.6443
  • Rsrq_variance is not normally distributed (p-value 1.5464950158591008e-06)

Rssnr_variance

numerical

Approximate Distinct Count 46
Approximate Unique (%) 92.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 8.2124
Minimum 0
Maximum 58.0292
Zeros 5
Zeros (%) 10.0%
Negatives 0
Negatives (%) 0.0%
  • Rssnr_variance is skewed right (γ1 = 2.6284)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 2.9504
Median 4.3764
Q3 6.4404
95-th Percentile 40.0825
Maximum 58.0292
Range 58.0292
IQR 3.49

Descriptive Statistics

Mean 8.2124
Standard Deviation 12.2811
Variance 150.8256
Sum 410.6181
Skewness 2.6284
Kurtosis 6.2127
Coefficient of Variation 1.4954
  • Rssnr_variance is not normally distributed (p-value 7.84649347059084e-12)
  • Rssnr_variance has 7 outliers

Rssi_variance

numerical

Approximate Distinct Count 37
Approximate Unique (%) 74.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 3.9272
Minimum 0
Maximum 13.6548
Zeros 14
Zeros (%) 28.0%
Negatives 0
Negatives (%) 0.0%
  • Rssi_variance is skewed right (γ1 = 0.6027)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 3.6703
Q3 6.7376
95-th Percentile 9.8971
Maximum 13.6548
Range 13.6548
IQR 6.7376

Descriptive Statistics

Mean 3.9272
Standard Deviation 3.597
Variance 12.9387
Sum 196.3604
Skewness 0.6027
Kurtosis -0.5419
Coefficient of Variation 0.9159
  • Rssi_variance is not normally distributed (p-value 2.3508697811632472e-20)

Brand

categorical

Approximate Distinct Count 3
Approximate Unique (%) 6.0%
Missing 0
Missing (%) 0.0%
Memory Size 3.6 KB
  • The largest value (Telefonica) is over 3.67 times larger than the second largest value (Vodafone)

Length

Mean 9.16
Standard Deviation 1.2182
Median 10
Minimum 7
Maximum 10

Sample

1st row Telefonica
2nd row Telefonica
3rd row Telefonica
4th row Telefonica
5th row Telefonica

Letter

Count 458
Lowercase Letter 408
Space Separator 0
Uppercase Letter 50
Dash Punctuation 0
Decimal Number 0
  • The top 2 categories (Telefonica, Vodafone) take over 50.0%
  • The largest value (telefonica) is over 3.67 times larger than the second largest value (vodafone)

Wifi_data_points_share

numerical

Approximate Distinct Count 22
Approximate Unique (%) 44.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 0.5324
Minimum 0
Maximum 1
Zeros 12
Zeros (%) 24.0%
Negatives 0
Negatives (%) 0.0%
  • Wifi_data_points_share is skewed left (γ1 = -0.0537)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0.03286
Median 0.4863
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 0.9671

Descriptive Statistics

Mean 0.5324
Standard Deviation 0.4341
Variance 0.1884
Sum 26.6222
Skewness -0.05367
Kurtosis -1.7764
Coefficient of Variation 0.8152
  • Wifi_data_points_share is not normally distributed (p-value 1.1491684317364516e-18)

Radius_activity_user

numerical

Approximate Distinct Count 42
Approximate Unique (%) 84.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 8775.4606
Minimum 0
Maximum 117245.6849
Zeros 9
Zeros (%) 18.0%
Negatives 0
Negatives (%) 0.0%
  • Radius_activity_user is skewed right (γ1 = 3.9653)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 11.655
Median 1841.3537
Q3 6701.5035
95-th Percentile 31876.7318
Maximum 117245.6849
Range 117245.6849
IQR 6689.8485

Descriptive Statistics

Mean 8775.4606
Standard Deviation 20506.1206
Variance 4.205e+08
Sum 438773.032
Skewness 3.9653
Kurtosis 16.4988
Coefficient of Variation 2.3368
  • Radius_activity_user is not normally distributed (p-value 3.2017869615354713e-22)
  • Radius_activity_user has 7 outliers

Radius_activity_state

numerical

Approximate Distinct Count 45
Approximate Unique (%) 90.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 800.0 B
Mean 6966.0634
Minimum 4631.6965
Maximum 9246.9172
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • Radius_activity_state is skewed left (γ1 = -0.0046)

Quantile Statistics

Minimum 4631.6965
5-th Percentile 5048.1116
Q1 5970.8365
Median 7032.0332
Q3 7782.0086
95-th Percentile 8916.5387
Maximum 9246.9172
Range 4615.2207
IQR 1811.1721

Descriptive Statistics

Mean 6966.0634
Standard Deviation 1207.9
Variance 1.459e+06
Sum 348303.1706
Skewness -0.004583
Kurtosis -0.8864
Coefficient of Variation 0.1734

Interactions

Correlations

Missing Values